CREATE EXTERNAL TABLE jms_dm.dm_traffic_flow_enough_direct_cnt_dt(
  `inputtime` date COMMENT '日期',
  `send_agent_code` string COMMENT '始发代理区code',
  `send_agent` string COMMENT '始发代理区name',
  `send_distributecode` string COMMENT '始发中心code',
  `send_distribute` string COMMENT '始发中心name',
  `receiver_distributecode` string COMMENT '目的中心code',
  `receiver_distribute` string COMMENT '目的中心name',
  `receiver_agent_code` string COMMENT '目的代理区code',
  `receiver_agent` string COMMENT '目的代理区name',
  `package_number` int COMMENT '正向件数',
  `package_total_weight` decimal(16,2) COMMENT '正向重量KG',
  `package_total_volume` decimal(16,2) COMMENT '正向体积m³',
  `mileage` decimal(16,2) COMMENT '规划里程KM',
  `vehicle_count` int COMMENT '核载票数',
  `route_name` string COMMENT '路由名称',
  `forcast_load_rt` decimal(10,4) COMMENT '预估装载率',
  `is_can_enough_drict_send` int COMMENT '是否够量直发',
  `is_can_stop_drict_send` int COMMENT '是否满足经停直发'
)comment '流量流向-够量直发统计'
PARTITIONED BY (dt STRING COMMENT '时间分区')
STORED AS PARQUET
LOCATION '/dw/hive/jms_dm.db/external/dm_traffic_flow_enough_direct_cnt_dt'
TBLPROPERTIES (
        'discover.partitions' = 'false',
        'parquet.column.index.access' = 'true'
);